package com.li.mapper;

import com.li.pojo.po.Contract;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDate;
import java.util.List;

@Mapper
public interface ImageReportMapper {

    @Select("select * from sys_contract where create_time between #{beginCreateTime} and #{endCreateTime}")
    List<Contract> findAllContractByDay(LocalDate beginCreateTime, LocalDate endCreateTime);

    Integer groupContractByTime(LocalDate begin, LocalDate end);

    Integer groupCluesByTime(LocalDate begin, LocalDate end);

    Integer sumMoneyByTime(LocalDate begin, LocalDate end);
}
